package com.chinasoft04.mall.mapper;

import com.chinasoft04.mall.pojo.Report;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;
@Mapper
public interface EchartsMapper {

    //获取地区
    @Select("select distinct rp1_area from sp_report_1")
    List<Report> getArea();

    //获取时间
    @Select("select distinct rp1_date from sp_report_1")
   List<Report> getDate();

    //根据地区获取数据
    @Select("select rp1_user_count from sp_report_1 where rp1_area=#{areaName}")
    List<Integer> selectUserCount(String areaName);



}
